1 <?php
2 session_start(); // Use session variable on this page. This function must put on the top of page.
3 if(!isset($_SESSION['username']) || $_SESSION['usertype'] !='admin'){ // if session variable "username" does not exist.
4 header("location:index.php?msg=Please%20login%20to%20access%20admin%20area%20!"); // Re-direct to index.php
5 }
6 else
7 {
8 include_once "db.php";
9 error_reporting (E_ALL ^ E_NOTICE);
10
11 ?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
12 "http://www.w3.org/TR/html4/loose.dtd">
13 <html>
14 <head>
15 <title>Welcome to Stock Management System !</title>
16 <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
17 <link rel="stylesheet" href="css/validationEngine.jquery.css" type="text/css" media="screen" title="no title" charset="utf-8" />
18 <link rel="stylesheet" href="css/template.css" type="text/css" media="screen" title="no title" charset="utf-8" />
19 <script src="js/jquery.min.js" type="text/javascript"></script>
20 <script type="text/javascript" src="jquery.date_input.js"></script>
21 <link rel="stylesheet" href="date_input.css" type="text/css">
22 <script type="text/javascript">$(function() {
23 $("#datefield").date_input();
24 });</script>
25
26 <script type='text/javascript' src='lib/jquery.bgiframe.min.js'></script>
27 <script type='text/javascript' src='lib/jquery.ajaxQueue.js'></script>
28 <script type='text/javascript' src='lib/thickbox-compressed.js'></script>
29 <script type='text/javascript' src='jquery.autocomplete.js'></script>
30 <script type='text/javascript' src='localdata.js'></script>
31
32 <link rel="stylesheet" type="text/css" href="jquery.autocomplete.css" />
33 <link rel="stylesheet" type="text/css" href="lib/thickbox.css" />
34
35 <script type="text/javascript">
36 $().ready(function() {
37
38 function log(event, data, formatted) {
39 $("<li>").html( !data ? "No match!" : "Selected: " + formatted).appendTo("#result");
40 }
41
42 function formatItem(row) {
43 return row[0] + " (<strong>id: " + row[1] + "</strong>)";
44 }
45 function formatResult(row) {
46 return row[0].replace(/(<.+?>)/gi, '');
47 }
48
49
50
51 $("#singleBirdRemote").autocomplete("stock.php", {
52 width: 160,
53 autoFill: true,
54 selectFirst: false
55 });
56 $("#supplier").autocomplete("supplier1.php", {
57 width: 160,
58 autoFill: true,
59 selectFirst: false
60 });
61 $("#category").autocomplete("category.php", {
62 width: 160,
63 autoFill: true,
64 selectFirst: false
65 });
66
67
68
69 $("#clear").click(function() {
70 $(":input").unautocomplete();
71 });
72 });
73
74
75 </script>
76
77 <script src="js/jquery.validationEngine-en.js" type="text/javascript"></script>
78 <script src="js/jquery.validationEngine.js" type="text/javascript"></script>
79 <script src="js/jquery.hotkeys-0.7.9.js"></script>
80 <!-- AJAX SUCCESS TEST FONCTION
81 <script>function callSuccessFunction(){alert("success executed")}
82 function callFailFunction(){alert("fail executed")}
83 </script>
84 -->
85
86 <script>
87
88
89
90
91
92 $(document).ready(function() {
93 // SUCCESS AJAX CALL, replace "success: false," by: success : function() { callSuccessFunction() },
94 $("#singleBirdRemote").focus();
95 $("#singleBirdRemote").blur(function()
96 {
97
98 $.post('check_stock_details.php', {stock_name: $(this).val() },
99 function(data){
100
101 // if(data=='no') //if username not avaiable
102 // {
103 // $("#category").focus();
104 // }
105 $("#category").val(data.category);
106 $("#supplier").val(data.supplier);
107 $("#buyingrate").val(data.buyingrate);
108 $("#sellingrate").val(data.sellingprice);
109
110 $("#available").val(data.available);
111 $("#quantity").focus();
112 }, 'json');
113
114
115
116
117
118 });
119
120 $("#form1").validationEngine(),
121
122 jQuery(document).bind('keydown', 'Ctrl+s',function() {
123 $('#form1').submit();
124 return false;
125 });
126
127 jQuery(document).bind('keydown', 'Ctrl+r',function() {
128 $('#form1').reset();
129 return false;
130 });
131 jQuery(document).bind('keydown', 'Ctrl+a',function() {
132 window.location = "add_stock_entry.php";
133 return false;
134 });
135 jQuery(document).bind('keydown', 'Ctrl+0',function() {
136 window.location = "admin.php";
137 return false;
138 });
139 jQuery(document).bind('keydown', 'Ctrl+1',function() {
140 window.location = "add_purchase.php";
141 return false;
142 });
143 jQuery(document).bind('keydown', 'Ctrl+2',function() {
144 window.location = "add_stock_sales.php";
145 return false;
146 });
147 jQuery(document).bind('keydown', 'Ctrl+3',function() {
148 window.location = "add_stock_details.php";
149 return false;
150 });
151 jQuery(document).bind('keydown', 'Ctrl+4',function() {
152 window.location = "add_category.php";
153 return false;
154 });
155 jQuery(document).bind('keydown', 'Ctrl+5',function() {
156 window.location = "add_supplier_details.php";
157 return false;
158 });
159 jQuery(document).bind('keydown', 'Ctrl+6',function() {
160 window.location = "add_customer_details.php";
161 return false;
162 });
163 jQuery(document).bind('keydown', 'Ctrl+7',function() {
164 window.location = "view_stock_entries.php";
165 return false;
166 });
167 jQuery(document).bind('keydown', 'Ctrl+8',function() {
168 window.location = "view_stock_sales.php";
169 return false;
170 });
171 jQuery(document).bind('keydown', 'Ctrl+9',function() {
172 window.location = "view_stock_details.php";
173 return false;
174 });
175 //$.validationEngine.loadValidation("#date")
176 //alert($("#formID").validationEngine({returnIsValid:true}))
177 //$.validationEngine.buildPrompt("#date","This is an example","error") // Exterior prompt build example // input prompt close example
178 //$.validationEngine.closePrompt(".formError",true) // CLOSE ALL OPEN PROMPTS
179 });
180 </script>
181 <style type="text/css">
182 <!--
183 body {
184 margin-left: 0px;
185 margin-top: 0px;
186 margin-right: 0px;
187 margin-bottom: 0px;
188 background-color: #FFFFFF;
189 }
190
191 *{
192 padding: 0px;
193 margin: 0px;
194 }
195 #vertmenu {
196 font-family: Verdana, Arial, Helvetica, sans-serif;
197 font-size: 100%;
198 width: 160px;
199 padding: 0px;
200 margin: 0px;
201 }
202
203 #vertmenu h1 {
204 display: block;
205 background-color:#FF9900;
206 font-size: 90%;
207 padding: 3px 0 5px 3px;
208 border: 1px solid #000000;
209 color: #333333;
210 margin: 0px;
211 width:159px;
212 }
213
214 #vertmenu ul {
215 list-style: none;
216 margin: 0px;
217 padding: 0px;
218 border: none;
219 }
220 #vertmenu ul li {
221 margin: 0px;
222 padding: 0px;
223 }
224 #vertmenu ul li a {
225 font-size: 80%;
226 display: block;
227 border-bottom: 1px dashed #C39C4E;
228 padding: 5px 0px 2px 4px;
229 text-decoration: none;
230 color: #666666;
231 width:160px;
232 }
233
234 #vertmenu ul li a:hover, #vertmenu ul li a:focus {
235 color: #000000;
236 background-color: #eeeeee;
237 }
238 .style1 {color: #000000}
239
240 -->
241 </style>
242 </head>
243
244 <body>
245 <table width="100%" border="0" cellspacing="0" cellpadding="0">
246 <tr>
247 <td align="center" valign="top"><table width="960" border="0" cellspacing="0" cellpadding="0">
248 <tr>
249 <td><table width="960" border="0" cellpadding="0" cellspacing="0" bgcolor="#ECECEC">
250 <tr>
251 <td height="90" align="left" valign="top"><img src="images/topbanner.jpg" width="960" height="82"></td>
252 </tr>
253 <tr>
254 <td height="800" align="left" valign="top"><table width="960" border="0" cellpadding="0" cellspacing="0" bgcolor="#ECECEC">
255 <tr>
256 <td width="130" align="left" valign="top">
257
258 <br>
259
260 <strong>Welcome <font color="#3399FF"><?php echo $_SESSION['username']; ?> !</font></strong><br> <br>
261 <table width="100%" border="0" cellspacing="0" cellpadding="0">
262 <tr>
263 <td align="center"><a href="admin.php"><img src="images/home.png" width="130" height="99" border="0"></a></td>
264 </tr>
265 <tr>
266 <td align="center"> </td>
267 </tr>
268 <tr>
269 <td align="center"><a href="add_purchase.php"><img src="images/purchase.png" width="130" height="124" border="0"></a></td>
270 </tr>
271 <tr>
272 <td align="center"> </td>
273 </tr>
274 <tr>
275 <td align="center"><a href="add_stock_sales.php"><img src="images/sales.png" width="146" height="111" border="0"></a></td>
276 </tr>
277 <tr>
278 <td align="center"> </td>
279 </tr>
280 <tr>
281 <td align="center"><a href="report.php"><img src="images/reports.png" width="131" height="142" border="0"></a></td>
282 </tr>
283 <tr>
284 <td align="center"> </td>
285 </tr>
286 <tr>
287 <td align="center"> </td>
288 </tr>
289 <tr>
290 <td align="center"> </td>
291 </tr>
292 </table>
293
294
295
296
297
298 </td> <td height="500" align="center" valign="top">
299 <table width="100%" border="0" cellspacing="0" cellpadding="0">
300 <tr>
301 <td><a href="add_stock_details.php"><img src="images/addstockdetails.png" width="67" height="62" border="0"></a></td>
302 <td><a href="add_supplier_details.php"><img src="images/supplier.png" width="67" height="54" border="0"></a></td>
303 <td><a href="add_customer_details.php"><img src="images/customer.png" width="67" height="54" border="0"></a></td>
304 <td><a href="add_category.php"><img src="images/categories.png" width="67" height="54" border="0"></a></td>
305 <td><a href="view_stock_sales.php"><img src="images/vsales.png" width="67" height="54" border="0"></a></td>
306 <td><a href="view_stock_entries.php"><img src="images/vpurchase.png" width="67" height="54" border="0"></a></td>
307 <td><a href="view_stock_details.php"><img src="images/stockdetails.png" width="67" height="54" border="0"></a></td>
308 <td><a href="view_stock_availability.php"><img src="images/savail.png" width="67" height="54" border="0"></a></td>
309 <td align="left" valign="top"><a href="view_customer_details.php"><img src="images/customers.png" width="94" height="22" border="0"></a><br> <a href="view_supplier_details.php"><img src="images/suppliers.png" width="94" height="22" border="0"></a><br>
310 <a href="view_payments.php"><img src="images/payments.png" width="94" height="22" border="0"></a></td>
311 <td align="left" valign="top"><a href="view_stock_sales_payments.php"><img src="images/outstanding.png" width="94" height="22" border="0"></a><br> <a href="view_stock_entries_payments.php"><img src="images/pendings.png" width="94" height="22" border="0"></a><br>
312 <a href="logout.php"><img src="images/logout.png" width="94" height="22" border="0"></a></td>
313 </tr>
314 </table>
315 <?php
316 if(isset($_POST['name']))
317
318 {
319
320 $name=mysql_real_escape_string($_POST['name']);
321 $category=mysql_real_escape_string($_POST['category']);
322 $buyingrate=mysql_real_escape_string($_POST['buyingrate']);
323 $sellingrate=mysql_real_escape_string($_POST['sellingrate']);
324 $suplier=mysql_real_escape_string($_POST['suplier']);
325 //$uom=mysql_real_escape_string($_POST['uom']);
326 $quantity=mysql_real_escape_string($_POST['quantity']);
327 $count = $db->countOf("stock_avail", "name='$name'");
328 $selected_date=$_POST['date'];
329 $selected_date=strtotime( $selected_date );
330 $mysqldate = date( 'Y-m-d H:i:s', $selected_date );
331 $username = $_SESSION['username'];
332
333 $max = $db->maxOfAll("id", "stock_details");
334 $max=$max+1;
335 $autoid="SD".$max."";
336 $max1 = $db->maxOfAll("id", "stock_details");
337 $max1=$max1+1;
338 $autoid1="SD".$max1."";
339 if($count==0)
340 {
341 $db->query("insert into stock_avail(name,quantity) values('$name',$quantity)");
342 echo "<br><font color=green size=+1 >New Stock Entry Inserted !</font>" ;
343
344 $db->query("insert into stock_details(stock_id,stock_name,stock_quatity,supplier_id,company_price,selling_price,category) values(' $autoid','$name',0,'$suplier',$buyingrate,$sellingrate,'$category')");
345 $db->query("insert into stock_entries (stock_id,stock_name,stock_supplier_name,category,quantity,company_price,selling_price,opening_stock,closing_stock,date,username,type) values('$autoid1','$name','$suplier','$category',$quantity,$buyingrate,$sellingrate,0,$quantity,'$mysqldate','$username','entry')");
346 }
347 else if($count==1)
348 {
349 $amount = $db->queryUniqueValue("SELECT quantity FROM stock_avail WHERE name='$name'");
350 $amount1 = $amount + $quantity;
351 $db->execute("UPDATE stock_avail SET quantity=$amount1 WHERE name='$name'");
352 $db->query("insert into stock_entries (stock_id,stock_name,stock_supplier_name,category,quantity,company_price,selling_price,opening_stock,closing_stock,date,username,type) values('$autoid1','$name','$suplier','$category',$quantity,$buyingrate,$sellingrate,$amount,$amount1,'$mysqldate','$username','entry')");
353
354 echo "<br><font color=green size=+1 >$quantity Quantity Added in $name !</font>" ;
355 }
356
357
358 }
359
360 ?>
361
362 <br>
363 <br>
364
365
366 <form name="form1" method="post" id="form1" action="">
367
368 <p align="center"><strong>Add New Stock Entry </strong> - Add New ( Control +A)</p>
369 <table width="600" border="0" cellspacing="0" cellpadding="0">
370 <tr>
371 <td width="150"> </td>
372 <td width="150"> </td>
373 <td width="150"> </td>
374 <td width="150"> </td>
375 </tr>
376 <tr>
377 <td width="150"> </td>
378 <td width="150"> </td>
379 <td width="150"> </td>
380 <td width="150"> </td>
381 </tr>
382 <tr>
383 <td width="150">ID <?php
384 $max = $db->maxOfAll("id","stock_entries");
385 $max=$max+1;
386 $autoid="SE".$max."";
387 ?></td>
388 <td width="150"><input name="id" type="text" id="id" readonly="" value="<?php echo $autoid; ?>"></td>
389 <td width="150">Date</td>
390
391 <td width="150"> <input type="text" id="datefield" name="date" class="date_input" value="<?php echo date('d-m-Y');?>"></td>
392 </tr>
393 <tr>
394 <td width="150"> </td>
395 <td width="150"> </td>
396 <td width="150"> </td>
397 <td width="150"> </td>
398 </tr>
399 <tr>
400 <td width="150"><strong>Name</strong></td>
401 <td width="150"><input name="name" type="text" id="singleBirdRemote" class="validate[required,length[0,100]] text-input"></td>
402 <td width="150">Category</td>
403 <td width="150"><input name="category" id="category" type="text" value="" ></td>
404 </tr>
405 <tr>
406 <td width="150"> </td>
407 <td width="150"> </td>
408 <td width="150"> </td>
409 <td width="150"> </td>
410 </tr>
411 <tr>
412 <td width="150">Supplier</td>
413 <td width="150"><input name="suplier" type="text" id="supplier" class="validate[optional,length[0,100]] text-input"></td>
414 <td width="150"> </td>
415 <td width="150"> </td>
416 </tr>
417 <tr>
418 <td> </td>
419 <td> </td>
420 <td> </td>
421 <td> </td>
422 </tr>
423 <tr>
424 <td>Buying Rate</td>
425 <td><input name="buyingrate" type="text" id="buyingrate" class="validate[required,custom[onlyNumber],lengthCheck[6]] text-input" ></td>
426 <td>Selling Rate </td>
427 <td><input name="sellingrate" type="text" id="sellingrate" class="validate[required,custom[onlyNumber],lengthCheck[6]] text-input" ></td>
428 </tr>
429 <tr>
430 <td> </td>
431 <td> </td>
432 <td> </td>
433 <td> </td>
434 </tr>
435 <tr>
436 <td><strong>Quantity</strong></td>
437 <td><input name="quantity" type="text" id="quantity" class="validate[required,custom[onlyNumber],lengthCheck[6]] text-input" ></td>
438 <td>Available Quantity </td>
439 <td><input name="available" type="text" id="available" value="" readonly=""></td>
440 </tr>
441 <tr>
442 <td> </td>
443 <td> </td>
444 <td> </td>
445 <td> </td>
446 </tr>
447 <tr>
448 <td> </td>
449 <td> </td>
450 <td> </td>
451 <td> </td>
452 </tr>
453 <tr>
454 <td> </td>
455 <td> </td>
456 <td> </td>
457 <td> </td>
458 </tr>
459 <tr>
460 <td align="right"> </td>
461 <td align="right"><input type="reset" name="Reset" value="Reset">
462 </td>
463 <td>
464 <input type="submit" name="Submit" value="Save"></td>
465 <td> </td>
466 </tr>
467 <tr>
468 <td align="center"> </td>
469 <td align="center"> (Control + R) </td>
470 <td align="left"> ( Control + S ) </td>
471 <td align="left"> </td>
472 </tr>
473 </table>
474 </form></td>
475 </tr>
476 </table>
477
478 </td>
479 </tr>
480 <tr>
481 <td height="30" align="center" bgcolor="#72C9F4"><span class="style1"><a href="http://www.pluskb.com">Developed by PlusKB Innovations</a></span></td>
482 </tr>
483 </table></td>
484 </tr>
485 </table></td>
486 </tr>
487 </table>
488
489 </body>
490 </html>
491 <?php
492 }
493 ?>